df_houses_prices = read.csv("house_prices.csv")
df_houses_prices %>% head()
##   MSSubClass LotFrontage LotShape X1stFlrSF TotalBsmtSF GrLivArea FireplaceQu
## 1         60          65      Reg       856         856      1710        <NA>
## 2         20          80      Reg      1262        1262      1262          TA
## 3         60          68      IR1       920         920      1786          TA
## 4         70          60      IR1       961         756      1717          Gd
## 5         60          84      IR1      1145        1145      2198          TA
## 6         50          85      IR1       796         796      1362        <NA>
##   GarageArea Heating ExterQual MasVnrArea BsmtFinSF1 BsmtUnfSF CentralAir
## 1        548    GasA        Gd        196        706       150          Y
## 2        460    GasA        TA          0        978       284          Y
## 3        608    GasA        Gd        162        486       434          Y
## 4        642    GasA        TA          0        216       540          Y
## 5        836    GasA        Gd        350        655       490          Y
## 6        480    GasA        TA          0        732        64          Y
##   SalePrice
## 1    208500
## 2    181500
## 3    223500
## 4    140000
## 5    250000
## 6    143000

Resumen de datos

df_houses_prices %>% summary() 
##    MSSubClass     LotFrontage     LotShape    X1stFlrSF     TotalBsmtSF    
##  Min.   : 20.0   Min.   : 21.00   IR1:484   Min.   : 334   Min.   :   0.0  
##  1st Qu.: 20.0   1st Qu.: 59.00   IR2: 41   1st Qu.: 882   1st Qu.: 795.8  
##  Median : 50.0   Median : 69.00   IR3: 10   Median :1087   Median : 991.5  
##  Mean   : 56.9   Mean   : 70.05   Reg:925   Mean   :1163   Mean   :1057.4  
##  3rd Qu.: 70.0   3rd Qu.: 80.00             3rd Qu.:1391   3rd Qu.:1298.2  
##  Max.   :190.0   Max.   :313.00             Max.   :4692   Max.   :6110.0  
##                  NA's   :259                                               
##    GrLivArea    FireplaceQu   GarageArea      Heating     ExterQual
##  Min.   : 334   Ex  : 24    Min.   :   0.0   Floor:   1   Ex: 52   
##  1st Qu.:1130   Fa  : 33    1st Qu.: 334.5   GasA :1428   Fa: 14   
##  Median :1464   Gd  :380    Median : 480.0   GasW :  18   Gd:488   
##  Mean   :1515   Po  : 20    Mean   : 473.0   Grav :   7   TA:906   
##  3rd Qu.:1777   TA  :313    3rd Qu.: 576.0   OthW :   2            
##  Max.   :5642   NA's:690    Max.   :1418.0   Wall :   4            
##                                                                    
##    MasVnrArea       BsmtFinSF1       BsmtUnfSF      CentralAir   SalePrice     
##  Min.   :   0.0   Min.   :   0.0   Min.   :   0.0   N:  95     Min.   : 34900  
##  1st Qu.:   0.0   1st Qu.:   0.0   1st Qu.: 223.0   Y:1365     1st Qu.:129975  
##  Median :   0.0   Median : 383.5   Median : 477.5              Median :163000  
##  Mean   : 103.7   Mean   : 443.6   Mean   : 567.2              Mean   :180921  
##  3rd Qu.: 166.0   3rd Qu.: 712.2   3rd Qu.: 808.0              3rd Qu.:214000  
##  Max.   :1600.0   Max.   :5644.0   Max.   :2336.0              Max.   :755000  
##  NA's   :8

Analisis de las variables

for (name in colnames(df_houses_prices)){
  print(name)
  print(df_houses_prices %>% select("var" = name) %>% 
    ggplot(aes(x=var, y=..density..)) + 
    geom_density(col="magenta", lwd=1, fill = "cyan" ) +
    theme_minimal())
  
}
## [1] "MSSubClass"
## Note: Using an external vector in selections is ambiguous.
## i Use `all_of(name)` instead of `name` to silence this message.
## i See <https://tidyselect.r-lib.org/reference/faq-external-vector.html>.
## This message is displayed once per session.

## [1] "LotFrontage"
## Warning: Removed 259 rows containing non-finite values (stat_density).

## [1] "LotShape"

## [1] "X1stFlrSF"

## [1] "TotalBsmtSF"

## [1] "GrLivArea"

## [1] "FireplaceQu"

## [1] "GarageArea"

## [1] "Heating"
## Warning: Groups with fewer than two data points have been dropped.
## Warning in max(ids, na.rm = TRUE): ningun argumento finito para max; retornando
## -Inf

## [1] "ExterQual"

## [1] "MasVnrArea"
## Warning: Removed 8 rows containing non-finite values (stat_density).

## [1] "BsmtFinSF1"

## [1] "BsmtUnfSF"

## [1] "CentralAir"

## [1] "SalePrice"

for (var_x in colnames(df_houses_prices)){
  for (var_y in colnames(df_houses_prices)){
    if (var_x != var_y){
      
      print(df_houses_prices %>% select("X" = var_x, "Y" =  var_y) %>% 
        ggplot(aes(x=X, y=Y)) + 
        geom_point(col = "blue") + ggtitle(paste0(var_y, " vs " ,var_x )) +
        theme_minimal())
      }
  }
  
}
## Note: Using an external vector in selections is ambiguous.
## i Use `all_of(var_x)` instead of `var_x` to silence this message.
## i See <https://tidyselect.r-lib.org/reference/faq-external-vector.html>.
## This message is displayed once per session.
## Note: Using an external vector in selections is ambiguous.
## i Use `all_of(var_y)` instead of `var_y` to silence this message.
## i See <https://tidyselect.r-lib.org/reference/faq-external-vector.html>.
## This message is displayed once per session.
## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 265 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 265 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

## Warning: Removed 259 rows containing missing values (geom_point).

## Warning: Removed 8 rows containing missing values (geom_point).

Imputación de data faltante

Verificacion de datos faltantes

colNas <- colnames(df_houses_prices)[!complete.cases(t(df_houses_prices))]
colNas
## [1] "LotFrontage" "FireplaceQu" "MasVnrArea"

Porcentaje de NAS

incompleteData <- df_houses_prices %>% select(colNas)
## Note: Using an external vector in selections is ambiguous.
## i Use `all_of(colNas)` instead of `colNas` to silence this message.
## i See <https://tidyselect.r-lib.org/reference/faq-external-vector.html>.
## This message is displayed once per session.
incompleteData
##      LotFrontage FireplaceQu MasVnrArea
## 1             65        <NA>        196
## 2             80          TA          0
## 3             68          TA        162
## 4             60          Gd          0
## 5             84          TA        350
## 6             85        <NA>          0
## 7             75          Gd        186
## 8             NA          TA        240
## 9             51          TA          0
## 10            50          TA          0
## 11            70        <NA>          0
## 12            85          Gd        286
## 13            NA        <NA>          0
## 14            91          Gd        306
## 15            NA          Fa        212
## 16            51        <NA>          0
## 17            NA          TA        180
## 18            72        <NA>          0
## 19            66        <NA>          0
## 20            70        <NA>          0
## 21           101          Gd        380
## 22            57          Gd          0
## 23            75          Gd        281
## 24            44          TA          0
## 25            NA          TA          0
## 26           110          Gd        640
## 27            60        <NA>          0
## 28            98          Gd        200
## 29            47          Gd          0
## 30            60        <NA>          0
## 31            50        <NA>          0
## 32            NA        <NA>          0
## 33            85        <NA>          0
## 34            70          Gd          0
## 35            60          Gd        246
## 36           108          Gd        132
## 37           112        <NA>          0
## 38            74          TA        650
## 39            68        <NA>          0
## 40            65        <NA>          0
## 41            84          TA        101
## 42           115          Gd          0
## 43            NA        <NA>          0
## 44            NA        <NA>          0
## 45            70        <NA>          0
## 46            61          Gd        412
## 47            48          Ex          0
## 48            84        <NA>          0
## 49            33        <NA>          0
## 50            66        <NA>          0
## 51            NA        <NA>          0
## 52            52          Gd          0
## 53           110        <NA>          0
## 54            68          Gd          0
## 55            60          TA          0
## 56           100          Gd        272
## 57            24        <NA>        456
## 58            89        <NA>          0
## 59            66          Gd       1031
## 60            60        <NA>          0
## 61            63        <NA>          0
## 62            60        <NA>          0
## 63            44          Gd        178
## 64            50        <NA>          0
## 65            NA        <NA>        573
## 66            76          Gd        344
## 67            NA          Gd        287
## 68            72        <NA>        167
## 69            47        <NA>          0
## 70            81          TA          0
## 71            95          Gd       1115
## 72            69        <NA>          0
## 73            74          TA         40
## 74            85        <NA>        104
## 75            60        <NA>          0
## 76            21        <NA>          0
## 77            NA        <NA>          0
## 78            50        <NA>          0
## 79            72        <NA>          0
## 80            60        <NA>          0
## 81           100          Gd        576
## 82            32        <NA>        443
## 83            78          Gd        468
## 84            80        <NA>         66
## 85            NA          TA         22
## 86           121          TA        284
## 87           122          Gd          0
## 88            40        <NA>         76
## 89           105        <NA>          0
## 90            60        <NA>          0
## 91            60        <NA>          0
## 92            85        <NA>        203
## 93            80        <NA>          0
## 94            60          Gd          0
## 95            69        <NA>          0
## 96            NA          TA         68
## 97            78        <NA>        183
## 98            73        <NA>         48
## 99            85        <NA>          0
## 100           77        <NA>          0
## 101           NA          TA         28
## 102           77          TA        336
## 103           64        <NA>          0
## 104           94        <NA>          0
## 105           NA          TA        600
## 106           75          Gd        768
## 107           60        <NA>          0
## 108           50        <NA>          0
## 109           85        <NA>          0
## 110          105          TA        480
## 111           75        <NA>          0
## 112           NA          TA          0
## 113           77          Gd        220
## 114           NA          Gd        184
## 115           61          TA          0
## 116           34          Fa       1129
## 117           NA          Po        116
## 118           74        <NA>          0
## 119           90          TA          0
## 120           65          Gd          0
## 121           NA          TA          0
## 122           50        <NA>          0
## 123           75        <NA>        135
## 124           55        <NA>          0
## 125           48          TA          0
## 126           60        <NA>          0
## 127           NA          TA          0
## 128           55          TA          0
## 129           69          Fa        266
## 130           69        <NA>         85
## 131           88          Gd        309
## 132           NA          TA         40
## 133           75        <NA>          0
## 134           NA        <NA>        136
## 135           78          TA          0
## 136           80          Gd        288
## 137           NA          Fa        196
## 138           82        <NA>         70
## 139           73          TA        320
## 140           65        <NA>          0
## 141           70          Po          0
## 142           78        <NA>          0
## 143           71        <NA>          0
## 144           78        <NA>        183
## 145           70        <NA>        336
## 146           24        <NA>         50
## 147           51        <NA>          0
## 148           NA          Gd        180
## 149           63        <NA>        120
## 150           NA        <NA>          0
## 151          120        <NA>          0
## 152          107          Gd        436
## 153           NA          Gd        252
## 154           NA          Gd          0
## 155           84        <NA>          0
## 156           60        <NA>          0
## 157           60        <NA>          0
## 158           92          Gd         84
## 159          100          Gd          0
## 160          134          Gd        456
## 161           NA        <NA>          0
## 162          110          Gd        664
## 163           95          Gd        226
## 164           55        <NA>          0
## 165           40        <NA>          0
## 166           62        <NA>          0
## 167           NA          Gd          0
## 168           86          Gd        300
## 169           62          Gd          0
## 170           NA          TA        653
## 171           NA        <NA>          0
## 172          141          Gd        112
## 173           44          TA          0
## 174           80          TA        491
## 175           47          TA        132
## 176           84          Gd          0
## 177           97          TA        268
## 178           NA          Gd          0
## 179           63          Gd        748
## 180           60        <NA>          0
## 181           NA          TA        456
## 182           54          Gd          0
## 183           60          Gd         98
## 184           63        <NA>          0
## 185           92        <NA>          0
## 186           90          TA          0
## 187           NA        <NA>          0
## 188           60        <NA>          0
## 189           64          TA        275
## 190           41          Gd          0
## 191           70          TA          0
## 192           NA        <NA>        138
## 193           68        <NA>          0
## 194           24        <NA>         50
## 195           60        <NA>          0
## 196           24          TA          0
## 197           79          Gd        205
## 198          174          Ex          0
## 199           92        <NA>          0
## 200           76          Gd        262
## 201           80        <NA>          0
## 202           75          Fa          0
## 203           50        <NA>          0
## 204           NA          Gd        205
## 205           50        <NA>          0
## 206           99        <NA>          0
## 207           40          TA          0
## 208           NA          Po          0
## 209           NA          Gd        128
## 210           75        <NA>        260
## 211           67        <NA>          0
## 212           83        <NA>          0
## 213           72          TA          0
## 214           43        <NA>          0
## 215           NA        <NA>        153
## 216           72          Fa         64
## 217           65        <NA>        266
## 218           57        <NA>          0
## 219           NA          TA        312
## 220           43        <NA>         16
## 221           73        <NA>          0
## 222           NA          TA          0
## 223           85          TA          0
## 224           70        <NA>          0
## 225          103          Ex        922
## 226           21        <NA>        142
## 227           82          TA        290
## 228           21        <NA>        127
## 229           70          Fa          0
## 230           43          TA         16
## 231           73        <NA>        220
## 232          174          TA        506
## 233           21          Po        297
## 234           75        <NA>          0
## 235           NA          TA         NA
## 236           21        <NA>        604
## 237           65        <NA>         98
## 238           NA        <NA>          0
## 239           93        <NA>        254
## 240           52          Gd          0
## 241           75        <NA>         36
## 242           40        <NA>          0
## 243           63        <NA>          0
## 244           75          TA          0
## 245           NA          Fa          0
## 246           80          TA        102
## 247           69        <NA>          0
## 248           75          TA          0
## 249           72        <NA>        101
## 250           NA          TA        472
## 251           55        <NA>          0
## 252           44          Gd        481
## 253           65        <NA>          0
## 254           85        <NA>        108
## 255           70        <NA>          0
## 256           66          TA        302
## 257           64        <NA>          0
## 258           68          Gd        180
## 259           80          TA        172
## 260           70        <NA>          0
## 261          120          TA        399
## 262           69          Gd        270
## 263           88          TA         46
## 264           50        <NA>          0
## 265           30        <NA>          0
## 266           78          TA        210
## 267           70          TA          0
## 268           60          Gd          0
## 269           71          Gd          0
## 270           NA          Fa        174
## 271           84          Gd          0
## 272           73          TA          0
## 273           92          Gd        348
## 274           80          Gd        183
## 275           76        <NA>          0
## 276           55        <NA>          0
## 277          129        <NA>          0
## 278          140        <NA>          0
## 279          107          Ex        315
## 280           83          TA        299
## 281           82          TA        340
## 282           60        <NA>         68
## 283           34          Gd        166
## 284           74          Gd         72
## 285           50        <NA>          0
## 286           35        <NA>          0
## 287           77          Gd          0
## 288           NA        <NA>          0
## 289           NA        <NA>         31
## 290           60        <NA>          0
## 291          120          Gd          0
## 292           55        <NA>          0
## 293           60          Gd          0
## 294           NA          TA         34
## 295           80          Gd        238
## 296           37        <NA>          0
## 297           75        <NA>          0
## 298           66          TA       1600
## 299           90          Gd        365
## 300           80          Gd          0
## 301           90          Gd         56
## 302           66          TA          0
## 303          118          TA        150
## 304           70        <NA>          0
## 305           87          Ex          0
## 306           80        <NA>        246
## 307          116          TA        246
## 308           NA        <NA>          0
## 309           NA        <NA>          0
## 310           90          Ex          0
## 311           NA          TA        112
## 312           50          Gd          0
## 313           65          Gd          0
## 314          150          Gd          0
## 315           60          Gd          0
## 316           71          Gd          0
## 317           94          TA        278
## 318           75          Gd          0
## 319           90          TA        256
## 320           NA          TA        225
## 321          111        <NA>        370
## 322           99          Gd        388
## 323           86          TA        172
## 324           49        <NA>          0
## 325           96          Gd        300
## 326           50        <NA>          0
## 327           32          Gd          0
## 328           80        <NA>        175
## 329           NA        <NA>          0
## 330           60        <NA>          0
## 331           NA        <NA>         84
## 332           70        <NA>          0
## 333           85          Gd        296
## 334           59          Gd        146
## 335           59          TA          0
## 336           NA          Gd          0
## 337           86          Gd        200
## 338           70        <NA>        113
## 339           91        <NA>          0
## 340           66        <NA>        176
## 341           85        <NA>          0
## 342           60        <NA>          0
## 343           NA        <NA>        340
## 344           63          Ex        616
## 345           36        <NA>          0
## 346           65          Gd          0
## 347           NA        <NA>          0
## 348           NA          Gd         30
## 349           36        <NA>        106
## 350           56          Ex        870
## 351           68          Gd        362
## 352           NA          TA          0
## 353           60        <NA>          0
## 354           60        <NA>          0
## 355           60          Gd          0
## 356          105        <NA>          0
## 357           NA        <NA>        106
## 358           44          Po          0
## 359           92        <NA>        120
## 360           78          TA        530
## 361           NA          TA          0
## 362           NA        <NA>          0
## 363           64          Ex        500
## 364           21        <NA>        510
## 365           NA          TA        120
## 366           59        <NA>          0
## 367           NA          Gd        247
## 368          101          Gd        305
## 369           78          Gd        200
## 370           NA          Gd          0
## 371           NA          TA          0
## 372           80          Gd          0
## 373           50        <NA>          0
## 374           79        <NA>          0
## 375           65          Gd          0
## 376           NA        <NA>          0
## 377           57        <NA>          0
## 378          102          Gd          0
## 379           88          Ex        350
## 380           60          TA         16
## 381           50          Gd          0
## 382           60          Gd          0
## 383           79        <NA>          0
## 384           60        <NA>          0
## 385           NA          Fa          0
## 386           43          TA         16
## 387           58        <NA>          0
## 388           72          Fa        255
## 389           93        <NA>        125
## 390           96          Ex        272
## 391           50        <NA>          0
## 392           71          TA          0
## 393           NA        <NA>          0
## 394           NA          TA          0
## 395           60        <NA>          0
## 396           68        <NA>          0
## 397           60        <NA>          0
## 398           69          TA        288
## 399           60        <NA>          0
## 400           65        <NA>        100
## 401           38          Gd          0
## 402           65          Gd          0
## 403           60        <NA>          0
## 404           93          TA        650
## 405           NA          TA          0
## 406           NA          TA          0
## 407           51        <NA>          0
## 408           63        <NA>          0
## 409          109          Gd        350
## 410           85          Gd        100
## 411           68        <NA>          0
## 412          100        <NA>          0
## 413           NA          Gd        432
## 414           56          Gd          0
## 415           59          TA          0
## 416           73        <NA>          0
## 417           74          TA        203
## 418           86          Gd          0
## 419           60        <NA>          0
## 420           65          Fa          0
## 421           78        <NA>        200
## 422           NA          TA        126
## 423          100        <NA>          0
## 424           80          TA        473
## 425           72          Gd         74
## 426           60          Gd          0
## 427           NA          TA        145
## 428           77        <NA>          0
## 429           64        <NA>        108
## 430          130          TA          0
## 431           21        <NA>        232
## 432           60        <NA>          0
## 433           24        <NA>        376
## 434          100          TA          0
## 435           21        <NA>          0
## 436           43          TA          0
## 437           40        <NA>          0
## 438           50        <NA>          0
## 439           40          Gd          0
## 440           67        <NA>          0
## 441          105          Gd        200
## 442           92        <NA>        270
## 443           52          Gd          0
## 444           53          Gd         72
## 445           70          TA          0
## 446           73          Gd          0
## 447          137          Gd          0
## 448           NA          TA          0
## 449           50          Gd          0
## 450           50        <NA>          0
## 451           70        <NA>          0
## 452           62          TA          0
## 453           NA        <NA>         42
## 454           75        <NA>          0
## 455           63        <NA>          0
## 456           80          TA        320
## 457           34        <NA>          0
## 458           NA          Gd          0
## 459           NA          Gd          0
## 460           NA          TA        161
## 461           75        <NA>        110
## 462           60        <NA>          0
## 463           60          Po          0
## 464           74          Gd          0
## 465           60        <NA>        136
## 466           NA          TA         18
## 467           85          Po          0
## 468           79          Gd        224
## 469           98          Gd        248
## 470           76        <NA>        120
## 471           NA        <NA>          0
## 472           92          Gd          0
## 473           35        <NA>         80
## 474          110          Ex        304
## 475           41        <NA>          0
## 476           80        <NA>          0
## 477           75          TA        215
## 478          105          Gd        772
## 479           79          Gd        336
## 480           50        <NA>        435
## 481           98          Gd        378
## 482           72          Gd        562
## 483           50          Gd          0
## 484           32        <NA>        116
## 485           NA        <NA>          0
## 486           80          Gd          0
## 487           79        <NA>        168
## 488           70          TA          0
## 489           60          Gd          0
## 490           21        <NA>          0
## 491           NA          Gd          0
## 492           79          TA          0
## 493          105        <NA>          0
## 494           70          Fa          0
## 495           50        <NA>          0
## 496           60        <NA>          0
## 497           NA          Gd          0
## 498           60        <NA>          0
## 499           65        <NA>         89
## 500           70        <NA>          0
## 501           21        <NA>        285
## 502           75        <NA>          0
## 503           70        <NA>          0
## 504          100          TA          0
## 505           24          Fa          0
## 506           60        <NA>        360
## 507           80          TA        125
## 508           75        <NA>          0
## 509           60          Gd          0
## 510           80        <NA>        132
## 511           75          TA         70
## 512           40          Gd         94
## 513           70        <NA>          0
## 514           71        <NA>          0
## 515           55        <NA>          0
## 516           94          Gd        305
## 517           NA          TA        333
## 518           79          TA        921
## 519           NA        <NA>          0
## 520           53          Gd          0
## 521           60        <NA>          0
## 522           90          Gd          0
## 523           50          Gd          0
## 524          130          Gd        762
## 525           95          TA        594
## 526           62          TA          0
## 527           70        <NA>          0
## 528           67          Gd        268
## 529           58        <NA>          0
## 530           NA          TA         NA
## 531           85          Fa        219
## 532           60        <NA>          0
## 533           60          Po          0
## 534           50        <NA>          0
## 535           74          Gd          0
## 536           70        <NA>          0
## 537           57        <NA>          0
## 538           NA        <NA>          0
## 539           NA          Fa        188
## 540           NA          TA        479
## 541           85          Gd        584
## 542           NA          TA         72
## 543           78          TA          0
## 544           34        <NA>        182
## 545           58          Gd          0
## 546           NA        <NA>        178
## 547           70          Gd          0
## 548           54        <NA>          0
## 549           49        <NA>          0
## 550           75          Gd          0
## 551           53        <NA>          0
## 552           50        <NA>          0
## 553           87          Gd        250
## 554           67        <NA>          0
## 555           85          Gd        292
## 556           58          Gd          0
## 557           69          TA          0
## 558           60        <NA>          0
## 559           57          TA          0
## 560           NA          TA         18
## 561           NA          Gd        180
## 562           77          TA          0
## 563           63          Gd          0
## 564           66          Gd          0
## 565           NA          TA          0
## 566           66        <NA>          0
## 567           77          Gd        245
## 568           70        <NA>        168
## 569           79          Gd          0
## 570           NA          TA          0
## 571           74        <NA>        108
## 572           60        <NA>        207
## 573           83        <NA>          0
## 574           76          TA          0
## 575           70        <NA>         82
## 576           80        <NA>          0
## 577           52          Gd          0
## 578           96          Fa         97
## 579           34        <NA>          0
## 580           81        <NA>        335
## 581           NA          Gd         85
## 582           98          Gd        306
## 583           81        <NA>        104
## 584           75          Gd          0
## 585           51        <NA>          0
## 586           88          Gd        208
## 587           55        <NA>          0
## 588           74        <NA>          0
## 589           65          Gd          0
## 590           50        <NA>          0
## 591           64        <NA>          0
## 592           97          Gd        420
## 593           60        <NA>          0
## 594           NA        <NA>        170
## 595           88        <NA>          0
## 596           69          TA        238
## 597           60        <NA>          0
## 598           53          Gd         72
## 599           80          TA        459
## 600           24          TA          0
## 601           74          Gd        280
## 602           50          Gd          0
## 603           80          TA          0
## 604           30        <NA>          0
## 605           88          TA         99
## 606           85          Fa        176
## 607           82        <NA>          0
## 608           78        <NA>          0
## 609           78          Gd          0
## 610           61        <NA>        192
## 611           NA          Ex        204
## 612           NA          TA        233
## 613           NA          TA        108
## 614           70        <NA>          0
## 615           21        <NA>          0
## 616           80        <NA>        156
## 617           NA          Gd          0
## 618           59        <NA>          0
## 619           90          Gd        452
## 620           85          Gd        226
## 621           45        <NA>          0
## 622           90          TA          0
## 623           71        <NA>        153
## 624           NA          TA        513
## 625           80          TA        288
## 626           87        <NA>        261
## 627           NA          TA          0
## 628           80          Gd        164
## 629           70          TA        192
## 630           82        <NA>        259
## 631           50        <NA>          0
## 632           34          Gd        108
## 633           85          TA        209
## 634           80        <NA>          0
## 635           64        <NA>          0
## 636           60        <NA>          0
## 637           51          Po          0
## 638           50        <NA>          0
## 639           67        <NA>          0
## 640           53          Gd          0
## 641           62          Gd        472
## 642           NA          TA          0
## 643           75          TA          0
## 644           80        <NA>        263
## 645           85          Gd        162
## 646           NA        <NA>          0
## 647           60        <NA>          0
## 648           85          Gd        216
## 649           70          TA        351
## 650           21        <NA>          0
## 651           65        <NA>         NA
## 652           60          Gd          0
## 653           70          TA          0
## 654           60        <NA>          0
## 655           91          TA        660
## 656           21        <NA>        381
## 657           72        <NA>         54
## 658           60          Gd          0
## 659           78          Gd          0
## 660           75        <NA>          0
## 661           NA          TA        233
## 662           52          TA        528
## 663          120          TA        216
## 664           90        <NA>          0
## 665           49          Ex          0
## 666          106          TA         40
## 667           NA          Po        113
## 668           65          Fa        258
## 669           NA          TA          0
## 670           80          Gd          0
## 671           64        <NA>          0
## 672           54        <NA>          0
## 673           NA          TA          0
## 674          110          TA        106
## 675           80          Gd          0
## 676           24          TA          0
## 677           60        <NA>          0
## 678           52        <NA>          0
## 679           80          Gd        464
## 680           NA        <NA>         57
## 681           50          TA          0
## 682           55        <NA>          0
## 683           NA          Gd          0
## 684           90          TA        215
## 685           58        <NA>         30
## 686           NA          TA          0
## 687           84        <NA>          0
## 688           NA        <NA>          0
## 689           60          Gd          0
## 690           61          Gd        256
## 691           NA          TA        147
## 692          104          Ex       1170
## 693           42          Gd        293
## 694           60        <NA>          0
## 695           51        <NA>          0
## 696           54          TA         72
## 697           50        <NA>          0
## 698           57        <NA>          0
## 699           65          Gd          0
## 700           59        <NA>          0
## 701           85          Gd        630
## 702           80        <NA>        168
## 703           82          Gd        466
## 704           76          Po          0
## 705           70        <NA>        109
## 706           70        <NA>          0
## 707           NA          TA        351
## 708           48          Gd        176
## 709           65          Gd          0
## 710           NA        <NA>         41
## 711           56        <NA>          0
## 712           66        <NA>          0
## 713           40          Gd          0
## 714           60        <NA>        160
## 715           NA        <NA>        289
## 716           78          TA        174
## 717           60        <NA>          0
## 718           80          Fa          0
## 719           96          TA        651
## 720           69          Po          0
## 721           NA          TA          0
## 722           NA        <NA>        169
## 723           70        <NA>          0
## 724           60        <NA>          0
## 725           86          Gd        340
## 726           60        <NA>          0
## 727           NA          Gd        260
## 728           64        <NA>         82
## 729           85        <NA>         95
## 730           52        <NA>          0
## 731           39          TA          0
## 732           73          Gd        442
## 733           75          TA        202
## 734           80          TA          0
## 735           NA        <NA>          0
## 736           60          TA          0
## 737           60        <NA>          0
## 738           72          Gd          0
## 739           60        <NA>          0
## 740           65        <NA>          0
## 741           60        <NA>          0
## 742           65        <NA>          0
## 743           65        <NA>        108
## 744           70          TA          0
## 745           41          TA          0
## 746           NA          TA        289
## 747           NA          TA          0
## 748           65          Gd          0
## 749           59          TA        338
## 750           50        <NA>          0
## 751           55        <NA>          0
## 752           NA        <NA>          0
## 753           79        <NA>          0
## 754           80          Gd        178
## 755           61        <NA>          0
## 756           34        <NA>        894
## 757           68        <NA>          0
## 758           NA          TA        328
## 759           24        <NA>        360
## 760           65          TA        513
## 761           70        <NA>          0
## 762           60        <NA>          0
## 763           72        <NA>          0
## 764           82          Gd        673
## 765           30          Gd          0
## 766           75          Gd        284
## 767           80          TA         42
## 768           75        <NA>          0
## 769           70          Gd          0
## 770           47          Gd        603
## 771           NA        <NA>          0
## 772           67        <NA>          0
## 773           94          TA          0
## 774           70        <NA>          1
## 775          110          Gd        375
## 776           32        <NA>        320
## 777           86        <NA>        240
## 778          100          Fa          0
## 779           60          TA        320
## 780           78        <NA>         90
## 781           63          TA         38
## 782           65        <NA>          0
## 783           67        <NA>          0
## 784           NA          TA        104
## 785           35          Gd          0
## 786           NA          Gd          0
## 787           60        <NA>          0
## 788           76        <NA>          0
## 789           50        <NA>          0
## 790           NA        <NA>        157
## 791           43          Gd         11
## 792           NA          TA          0
## 793           92          TA          0
## 794           76        <NA>        140
## 795           NA          TA          0
## 796           70          TA        130
## 797           71          TA        148
## 798           57        <NA>          0
## 799          104          Gd        860
## 800           60          TA        252
## 801           79        <NA>          0
## 802           40        <NA>          0
## 803           63          Gd          0
## 804          107          Gd        424
## 805           75        <NA>          0
## 806           91        <NA>        256
## 807           75        <NA>          0
## 808          144          TA          0
## 809           85          Gd       1047
## 810           90        <NA>          0
## 811           78          Fa         99
## 812           NA          Gd        169
## 813           66        <NA>          0
## 814           75        <NA>        243
## 815           45        <NA>          0
## 816           48        <NA>        442
## 817           NA          Gd          0
## 818           NA          Gd        148
## 819           80        <NA>         80
## 820           44          Gd        128
## 821           72        <NA>          0
## 822           60        <NA>          0
## 823           NA          Gd          0
## 824           60          Gd          0
## 825           81          Gd          0
## 826          114          Gd        816
## 827           50        <NA>          0
## 828           65          TA          0
## 829           NA        <NA>          0
## 830           24        <NA>          0
## 831           80          Gd        387
## 832           30        <NA>          0
## 833           44          TA        223
## 834          100        <NA>        180
## 835           75        <NA>        136
## 836           60        <NA>          0
## 837           90        <NA>          0
## 838           21        <NA>        158
## 839           75        <NA>          0
## 840           70        <NA>          0
## 841           NA        <NA>          0
## 842           60          Po          0
## 843           82        <NA>        183
## 844           80        <NA>          0
## 845          100          Gd          0
## 846           NA          TA          0
## 847           75          TA        137
## 848           36          Fa          0
## 849           75          Gd          0
## 850           80          TA        360
## 851           36        <NA>        170
## 852           NA          TA         40
## 853           53          Gd          0
## 854           NA          Fa        115
## 855          102          Gd          0
## 856           NA        <NA>          0
## 857           NA        <NA>          0
## 858           65          TA          0
## 859           80          TA        189
## 860           NA          Gd        220
## 861           55          Gd          0
## 862           75        <NA>          0
## 863           81        <NA>          0
## 864           70        <NA>          0
## 865           72        <NA>          0
## 866           NA        <NA>         76
## 867           67          Gd        274
## 868           85        <NA>          0
## 869           NA          TA          0
## 870           80          TA        246
## 871           60        <NA>          0
## 872           70        <NA>        116
## 873           74        <NA>          0
## 874           60          Gd          0
## 875           52        <NA>          0
## 876           75          Gd          0
## 877           94        <NA>          0
## 878           74          Gd        216
## 879           88        <NA>          0
## 880           NA        <NA>         90
## 881           60        <NA>          0
## 882           44          TA        117
## 883           NA          TA          0
## 884           60        <NA>          0
## 885           65        <NA>         60
## 886           50          TA         60
## 887           70        <NA>        122
## 888           59        <NA>          0
## 889           95          TA          0
## 890          128          TA         90
## 891           60          Po          0
## 892           70          TA         92
## 893           70        <NA>          0
## 894           NA          Gd          0
## 895           64        <NA>          0
## 896           71          TA        415
## 897           50        <NA>          0
## 898           64        <NA>          0
## 899          100          Gd        760
## 900           65          TA          0
## 901           NA        <NA>          0
## 902           64        <NA>          0
## 903           63          Gd          0
## 904           50          Gd         27
## 905           NA        <NA>         75
## 906           80        <NA>        110
## 907          116          Gd        208
## 908           86          Gd          0
## 909           NA        <NA>          0
## 910          149          Gd          0
## 911           80        <NA>        361
## 912           NA        <NA>          0
## 913           51        <NA>          0
## 914           82        <NA>          0
## 915           30        <NA>         76
## 916           21        <NA>         80
## 917           50        <NA>          0
## 918           NA        <NA>          0
## 919          103          TA          0
## 920           87          TA          0
## 921           70        <NA>        105
## 922           67        <NA>          0
## 923           65          Gd          0
## 924           50          Fa          0
## 925           79          TA        157
## 926           NA        <NA>          0
## 927           93          Gd        340
## 928           NA          Gd        342
## 929           NA          TA          0
## 930           NA          TA        285
## 931           73        <NA>          0
## 932           70        <NA>          0
## 933           84          Gd        302
## 934           63        <NA>        210
## 935          313          Gd          0
## 936           52        <NA>        108
## 937           67        <NA>         NA
## 938           75          Gd          0
## 939           73        <NA>          0
## 940           NA          TA          0
## 941           55        <NA>          0
## 942           NA          TA        298
## 943           42        <NA>          0
## 944          100        <NA>          0
## 945           NA          Gd        541
## 946           98        <NA>          0
## 947           70          TA        128
## 948           85          Gd        236
## 949           65          TA        144
## 950           78          TA          0
## 951           60        <NA>          0
## 952           60        <NA>          0
## 953           60        <NA>          0
## 954           NA          Po        232
## 955           35        <NA>        250
## 956           82        <NA>        423
## 957           24          TA          0
## 958           70        <NA>          0
## 959           65        <NA>          0
## 960           24        <NA>          0
## 961           50        <NA>          0
## 962           NA          TA        424
## 963           24          TA          0
## 964          122        <NA>          0
## 965           80          Gd         44
## 966           65          Gd          0
## 967          130          TA          0
## 968           NA        <NA>        151
## 969           50        <NA>          0
## 970           75        <NA>        105
## 971           60        <NA>          0
## 972           36        <NA>        106
## 973           55          TA          0
## 974           95        <NA>         NA
## 975           60        <NA>          0
## 976           NA        <NA>          0
## 977           51        <NA>          0
## 978           35        <NA>         NA
## 979           68        <NA>          0
## 980           80        <NA>          0
## 981           NA        <NA>        210
## 982           98          TA        975
## 983           43          Gd         16
## 984           NA          Gd          0
## 985           75        <NA>          0
## 986           68        <NA>          0
## 987           59        <NA>          0
## 988           83          Gd        450
## 989           NA          TA        298
## 990           65        <NA>          0
## 991           82          TA        423
## 992          121          Gd          0
## 993           80          Fa        340
## 994           68        <NA>          0
## 995           96          Gd        230
## 996           51        <NA>          0
## 997           NA        <NA>          0
## 998           NA          TA        571
## 999           60          Gd          0
## 1000          64        <NA>         24
## 1001          74        <NA>          0
## 1002          60        <NA>          0
## 1003          75          Gd         53
## 1004          NA        <NA>        164
## 1005          43          Gd         16
## 1006          65        <NA>        220
## 1007          NA          TA          0
## 1008          21        <NA>          0
## 1009          43          Gd        108
## 1010          60        <NA>          0
## 1011         115          Gd          0
## 1012          75        <NA>          0
## 1013          55          TA          0
## 1014          60        <NA>          0
## 1015          60          Gd        206
## 1016          70        <NA>          0
## 1017          73          TA        196
## 1018          NA          Ex          0
## 1019          NA          TA         76
## 1020          43          Gd        145
## 1021          60        <NA>          0
## 1022          64        <NA>         84
## 1023          52        <NA>          0
## 1024          43          Gd         14
## 1025          NA          Gd          0
## 1026          70        <NA>          0
## 1027          73          Gd        324
## 1028          71          Gd        338
## 1029          79          Gd          0
## 1030          21        <NA>        281
## 1031          NA        <NA>          0
## 1032         102          TA          0
## 1033          NA          TA          0
## 1034          NA        <NA>        295
## 1035          50          Gd          0
## 1036          NA        <NA>          0
## 1037          89          Ex         70
## 1038          NA          TA        396
## 1039          21          TA          0
## 1040          21        <NA>          0
## 1041          88          TA         67
## 1042          NA        <NA>        252
## 1043          34          Gd        135
## 1044          86          Ex         99
## 1045          80          Gd          0
## 1046          NA          Gd          0
## 1047          85          Gd        208
## 1048          57        <NA>          0
## 1049         100          TA         75
## 1050          60        <NA>          0
## 1051          73        <NA>          0
## 1052         103          Gd          0
## 1053         100          TA        272
## 1054          68          Gd        145
## 1055          90          Gd        210
## 1056         104          TA        160
## 1057          43          Gd        240
## 1058          NA          Gd          0
## 1059          96          Gd        154
## 1060          NA          Gd        480
## 1061          41        <NA>          0
## 1062         120        <NA>          0
## 1063          85        <NA>          0
## 1064          50          Gd          0
## 1065          NA          Po        200
## 1066          80        <NA>          0
## 1067          59          TA          0
## 1068          80        <NA>        360
## 1069          42          Gd          0
## 1070          60        <NA>          0
## 1071          72        <NA>        120
## 1072          78        <NA>          0
## 1073          50          TA          0
## 1074          75        <NA>        140
## 1075          74        <NA>          0
## 1076          75          Gd          0
## 1077          60          TA          0
## 1078          NA        <NA>          0
## 1079          37          Gd        169
## 1080          65        <NA>          0
## 1081          80        <NA>        144
## 1082          75        <NA>          0
## 1083          70          Gd        100
## 1084          80          Gd        425
## 1085          NA          TA          0
## 1086          73        <NA>          0
## 1087          NA        <NA>          0
## 1088          85          Gd          0
## 1089          24        <NA>         50
## 1090          37          Gd          0
## 1091          60        <NA>          0
## 1092          24        <NA>        212
## 1093          60          Gd          0
## 1094          71        <NA>        166
## 1095          74        <NA>          0
## 1096          78          Gd          0
## 1097          60        <NA>          0
## 1098          NA        <NA>          0
## 1099          50        <NA>          0
## 1100          82          TA        206
## 1101          60        <NA>          0
## 1102          61        <NA>          0
## 1103          70        <NA>         45
## 1104          79          Fa          0
## 1105          24        <NA>        304
## 1106          98          TA        362
## 1107         114          TA          0
## 1108         168          Gd          0
## 1109          NA          TA          0
## 1110         107          Gd         42
## 1111          NA          TA          0
## 1112          80          Gd        660
## 1113          73        <NA>          0
## 1114          66        <NA>          0
## 1115          90        <NA>          0
## 1116          93          Gd        328
## 1117          NA          TA          0
## 1118          57        <NA>          0
## 1119          85        <NA>          0
## 1120          70        <NA>          0
## 1121          59          Gd          0
## 1122          84        <NA>        196
## 1123          NA        <NA>          0
## 1124          50        <NA>          0
## 1125          NA          TA        170
## 1126          60          TA          0
## 1127          53          TA        130
## 1128         182          Gd          0
## 1129          59          Gd          0
## 1130          60        <NA>        180
## 1131          65          TA          0
## 1132          63        <NA>          0
## 1133          90        <NA>          0
## 1134          80          TA          0
## 1135          57          TA          0
## 1136          60          Gd          0
## 1137          80        <NA>          0
## 1138          54        <NA>          0
## 1139          NA          TA          0
## 1140          98          Gd          0
## 1141          60        <NA>          0
## 1142          NA          TA         44
## 1143          77          TA        340
## 1144          NA        <NA>          0
## 1145          60        <NA>          0
## 1146          52          Gd          0
## 1147          NA          TA         85
## 1148          75          Gd          0
## 1149          NA          Gd          0
## 1150          50        <NA>          0
## 1151          57          Gd          0
## 1152         134          Gd        132
## 1153          90          Gd          0
## 1154          NA        <NA>          0
## 1155          NA          Gd        288
## 1156          90          Fa          0
## 1157          85          Gd          0
## 1158          34          Gd        166
## 1159          92        <NA>        186
## 1160          76          TA        270
## 1161          24          TA          0
## 1162          NA          Gd         72
## 1163         109          Po          0
## 1164          60        <NA>          0
## 1165          NA          TA          0
## 1166          79        <NA>        268
## 1167          64        <NA>         72
## 1168          58          TA          0
## 1169         120          TA          0
## 1170         118          TA       1378
## 1171          76          Po          0
## 1172          76          TA          0
## 1173          35        <NA>          0
## 1174         138          Gd          0
## 1175          80          Gd          0
## 1176          85          TA        337
## 1177          37        <NA>          0
## 1178          NA        <NA>          0
## 1179          54          Gd          0
## 1180          77          Gd          0
## 1181          NA        <NA>          0
## 1182          64          Gd        186
## 1183         160          TA          0
## 1184          60          Gd          0
## 1185          50          TA        226
## 1186          60        <NA>          0
## 1187         107        <NA>          0
## 1188          89          Fa          0
## 1189          68        <NA>         95
## 1190          60          TA          0
## 1191          NA          TA        149
## 1192          24        <NA>        456
## 1193          60        <NA>          0
## 1194          NA        <NA>        425
## 1195          80        <NA>        143
## 1196          51        <NA>          0
## 1197          58          Gd          0
## 1198          65          Gd          0
## 1199          70        <NA>          0
## 1200          75          Po         51
## 1201          71        <NA>          0
## 1202          80        <NA>          0
## 1203          50          Fa          0
## 1204          75          TA        171
## 1205          78        <NA>          0
## 1206          90          TA        234
## 1207          NA        <NA>          0
## 1208          70        <NA>        120
## 1209          70        <NA>          0
## 1210          85          Gd        420
## 1211          70          TA          0
## 1212         152        <NA>          0
## 1213          50        <NA>          0
## 1214          NA        <NA>          0
## 1215          69        <NA>          0
## 1216          99        <NA>          0
## 1217          68        <NA>          0
## 1218          72        <NA>         72
## 1219          52        <NA>          0
## 1220          21        <NA>        236
## 1221          66        <NA>          0
## 1222          55          TA          0
## 1223          78          Gd        320
## 1224          89        <NA>         44
## 1225          60          Gd          0
## 1226          65        <NA>         63
## 1227          86          Gd         74
## 1228          72        <NA>        300
## 1229          65          Gd        766
## 1230          70        <NA>          0
## 1231          NA          TA          1
## 1232          70        <NA>        120
## 1233          70        <NA>          0
## 1234          NA        <NA>        180
## 1235          55        <NA>          0
## 1236          96        <NA>          0
## 1237          36        <NA>        106
## 1238          41          Gd          0
## 1239          63        <NA>          0
## 1240          64          Gd         32
## 1241          65        <NA>        252
## 1242          83        <NA>          0
## 1243          85          TA         81
## 1244         107          Gd         NA
## 1245          NA          Gd          0
## 1246          78          TA         74
## 1247          65        <NA>          0
## 1248          NA        <NA>        335
## 1249          60          Gd          0
## 1250          60        <NA>          0
## 1251          93          TA          0
## 1252          NA          Gd        163
## 1253          62        <NA>          0
## 1254          NA          Gd          0
## 1255          60          Gd         92
## 1256          52          Gd          0
## 1257          91          TA        554
## 1258          56        <NA>          0
## 1259          59        <NA>        182
## 1260          65        <NA>          0
## 1261          NA          TA          0
## 1262          80        <NA>          0
## 1263          NA          TA          0
## 1264          60          Gd          0
## 1265          34        <NA>          0
## 1266          35        <NA>        218
## 1267          60          Gd          0
## 1268          89          Gd          0
## 1269          NA          Gd        632
## 1270          78        <NA>        180
## 1271          NA          TA          0
## 1272          NA          Gd          0
## 1273          NA        <NA>        114
## 1274         124          Gd         84
## 1275          53          Gd          0
## 1276          95        <NA>        567
## 1277          NA          TA          0
## 1278          NA          Gd        359
## 1279          75          Gd         NA
## 1280          60        <NA>          0
## 1281          67        <NA>        110
## 1282          50          TA         54
## 1283          61        <NA>          0
## 1284          94        <NA>          0
## 1285          50          Gd          0
## 1286          50          Gd          0
## 1287          NA          Gd        451
## 1288          NA        <NA>        621
## 1289          40          Ex          0
## 1290          86          Gd        788
## 1291          NA          Gd         86
## 1292          21        <NA>        268
## 1293          60        <NA>          0
## 1294          78          TA          0
## 1295          60        <NA>          0
## 1296          70        <NA>        168
## 1297          80        <NA>        148
## 1298          35        <NA>         82
## 1299         313          Gd        796
## 1300          75        <NA>          0
## 1301          NA          TA        344
## 1302          NA          Gd          0
## 1303          92          TA        391
## 1304          73        <NA>        228
## 1305          32        <NA>        117
## 1306         108          Ex        300
## 1307          48          Gd         94
## 1308          60        <NA>          0
## 1309         100        <NA>          0
## 1310          NA        <NA>         88
## 1311         100          TA          0
## 1312          68        <NA>         80
## 1313          NA          Ex        336
## 1314         108          TA        165
## 1315          60          TA          0
## 1316          85          Gd          0
## 1317          61          Gd        270
## 1318          47          Gd          0
## 1319          NA          TA        178
## 1320          75        <NA>        132
## 1321          70          Gd          0
## 1322          NA        <NA>          0
## 1323         107          TA          0
## 1324          50        <NA>          0
## 1325          75          Gd        428
## 1326          40        <NA>          0
## 1327          70        <NA>          0
## 1328          60          Ex          0
## 1329          60          TA          0
## 1330          63          TA          0
## 1331          85          Gd        410
## 1332          55        <NA>          0
## 1333          67          Gd          0
## 1334          60        <NA>          0
## 1335          24        <NA>        312
## 1336          80          TA        360
## 1337          87        <NA>        564
## 1338         153        <NA>          0
## 1339          95        <NA>          0
## 1340         120        <NA>          0
## 1341          70        <NA>          0
## 1342          66        <NA>          0
## 1343          NA          Gd        149
## 1344          57          TA          0
## 1345          85          TA          0
## 1346          50        <NA>          0
## 1347          NA          Gd          0
## 1348          93          Gd        100
## 1349          NA          Fa          0
## 1350          50        <NA>          0
## 1351          91        <NA>        368
## 1352          70          Gd        318
## 1353          50        <NA>          0
## 1354          56          Ex        579
## 1355          NA          TA          0
## 1356         102          TA        143
## 1357          NA        <NA>         65
## 1358          NA          Fa          0
## 1359          NA        <NA>        216
## 1360         129          Gd         66
## 1361          51        <NA>          0
## 1362         124          Gd         16
## 1363          NA          Gd          0
## 1364          73          Gd          0
## 1365          30        <NA>          0
## 1366          NA        <NA>          0
## 1367          68        <NA>        158
## 1368          41          TA          0
## 1369          NA        <NA>        170
## 1370          48          TA        171
## 1371          90        <NA>          0
## 1372          80          TA          0
## 1373          75          TA          0
## 1374          NA          Gd        705
## 1375          85          Gd          0
## 1376          89          Gd         80
## 1377          52        <NA>          0
## 1378          60        <NA>          0
## 1379          21        <NA>        408
## 1380          73        <NA>          0
## 1381          45        <NA>          0
## 1382          NA          Gd          0
## 1383          60        <NA>          0
## 1384          NA        <NA>          0
## 1385          60        <NA>          0
## 1386          40        <NA>          0
## 1387          80          TA        184
## 1388          60          Gd          0
## 1389          42          Gd        160
## 1390          60          Gd          0
## 1391          70        <NA>        244
## 1392          65        <NA>          0
## 1393          68          Po          0
## 1394          60          TA          0
## 1395          53          Gd         45
## 1396          88          Gd        245
## 1397          NA          TA          0
## 1398          51        <NA>          0
## 1399          60        <NA>          0
## 1400          51          Gd          0
## 1401          50          Gd          0
## 1402          62          TA          0
## 1403          64          Gd          0
## 1404          49        <NA>         84
## 1405          60        <NA>          0
## 1406          44          Gd        174
## 1407          70        <NA>          0
## 1408          NA        <NA>          0
## 1409          60        <NA>          0
## 1410          46          TA        123
## 1411          79        <NA>          0
## 1412          80        <NA>          0
## 1413          60        <NA>          0
## 1414          88          Gd        366
## 1415          64          Gd          0
## 1416          51          TA        130
## 1417          60        <NA>          0
## 1418          NA          TA        731
## 1419          71        <NA>          0
## 1420          NA          TA        312
## 1421          90          TA        420
## 1422          53          Fa          0
## 1423          37        <NA>        170
## 1424          NA          Gd          0
## 1425          NA          TA          0
## 1426          80        <NA>        243
## 1427          81          TA        448
## 1428          60          TA          0
## 1429          60          Gd        294
## 1430          NA          TA        310
## 1431          60          Gd          0
## 1432          NA        <NA>          0
## 1433          60        <NA>          0
## 1434          93          TA        318
## 1435          80          Gd          0
## 1436          80          Gd        237
## 1437          60        <NA>          0
## 1438          96          Gd        426
## 1439          90        <NA>          0
## 1440          80          TA         96
## 1441          79          Gd          0
## 1442          NA          TA        147
## 1443          85          Ex        160
## 1444          NA          Gd          0
## 1445          63        <NA>        106
## 1446          70        <NA>          0
## 1447          NA        <NA>        189
## 1448          80          TA        438
## 1449          70        <NA>          0
## 1450          21        <NA>          0
## 1451          60        <NA>          0
## 1452          78          Gd        194
## 1453          35        <NA>         80
## 1454          90        <NA>          0
## 1455          62        <NA>          0
## 1456          62          TA          0
## 1457          85          TA        119
## 1458          66          Gd          0
## 1459          68        <NA>          0
## 1460          75        <NA>          0

Calculo porcentaje NA

porcentajeNAS <- as.data.frame(apply(incompleteData, MARGIN = 2, function(col) mean(is.na(col))))

colnames(porcentajeNAS ) <- c("porcentaje")

porcentajeNAS
##              porcentaje
## LotFrontage 0.177397260
## FireplaceQu 0.472602740
## MasVnrArea  0.005479452
procesables <- porcentajeNAS %>% filter(
  porcentajeNAS < 0.05
)
procesables
##             porcentaje
## MasVnrArea 0.005479452